{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "helper load finish!!!\n"
     ]
    }
   ],
   "source": [
    "from  base_helper import *"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(31179, 2)\n",
      "(31198, 1)\n"
     ]
    }
   ],
   "source": [
    "label_train = get_tag_train_new()\n",
    "label_test = get_sub()\n",
    "label_test.pop(tag_hd.Tag)\n",
    "print(label_train.shape)\n",
    "print(label_test.shape)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\ljt\\Anaconda3\\lib\\site-packages\\IPython\\core\\interactiveshell.py:2802: DtypeWarning: Columns (8) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  if self.run_code(code, result):\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1460843, 21)\n",
      "(1460843, 21)\n",
      "     UID  day              mode  success      time   os version  \\\n",
      "0  10035   30  c8741ce15ceac2a4      1.0  17:51:50  102   7.0.9   \n",
      "1  16264   16  20a91b45ef8f8221      1.0  08:36:00  200   7.0.9   \n",
      "\n",
      "            device1   device2      device_code1 ...       device_code3  \\\n",
      "0  49dd36968dbfadda  OPPO R11  ecb58082e0e9b8e2 ...   92342dea2ad2240d   \n",
      "1  49dd36968dbfadda  OPPO R11  ecb58082e0e9b8e2 ...   92342dea2ad2240d   \n",
      "\n",
      "               mac1              mac2               ip1               ip2  \\\n",
      "0  a8dc52f65085212e  a8dc52f65085212e  55dd8936655c86f6  fc7fc47d6c93f554   \n",
      "1  a8dc52f65085212e  a8dc52f65085212e  55dd8936655c86f6  fc7fc47d6c93f554   \n",
      "\n",
      "               wifi geo_code           ip1_sub           ip2_sub  Tag  \n",
      "0  4ff1553b1c96360e     wskx  e58e48fb9215116e  3502c553ea2ac187  1.0  \n",
      "1  4ff1553b1c96360e     wskx  e58e48fb9215116e  3502c553ea2ac187  0.0  \n",
      "\n",
      "[2 rows x 21 columns]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UID</th>\n",
       "      <th>channel</th>\n",
       "      <th>day</th>\n",
       "      <th>time</th>\n",
       "      <th>trans_amt</th>\n",
       "      <th>amt_src1</th>\n",
       "      <th>merchant</th>\n",
       "      <th>code1</th>\n",
       "      <th>code2</th>\n",
       "      <th>trans_type1</th>\n",
       "      <th>...</th>\n",
       "      <th>bal</th>\n",
       "      <th>amt_src2</th>\n",
       "      <th>acc_id2</th>\n",
       "      <th>acc_id3</th>\n",
       "      <th>geo_code</th>\n",
       "      <th>trans_type2</th>\n",
       "      <th>market_code</th>\n",
       "      <th>market_type</th>\n",
       "      <th>ip1_sub</th>\n",
       "      <th>Tag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>19092</td>\n",
       "      <td>102</td>\n",
       "      <td>30</td>\n",
       "      <td>11:48:47</td>\n",
       "      <td>1459</td>\n",
       "      <td>acdbdb842ac20f1e</td>\n",
       "      <td>abc6bc660561e0eb</td>\n",
       "      <td>f05a93833cfa2542</td>\n",
       "      <td>0f3c399dc9405713</td>\n",
       "      <td>26bcf43a19df14c8</td>\n",
       "      <td>...</td>\n",
       "      <td>1007</td>\n",
       "      <td>9fefed0a981dcb7a</td>\n",
       "      <td>01092023fb4f373d</td>\n",
       "      <td>99b877d5d88e8478</td>\n",
       "      <td>wsbq</td>\n",
       "      <td>102.0</td>\n",
       "      <td>2ecf94369847c748</td>\n",
       "      <td>1.0</td>\n",
       "      <td>45f4ca1f4e9b9cb7</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>13465</td>\n",
       "      <td>140</td>\n",
       "      <td>23</td>\n",
       "      <td>16:58:03</td>\n",
       "      <td>725</td>\n",
       "      <td>4d7831c6f695ab19</td>\n",
       "      <td>7a87b1aa20972d48</td>\n",
       "      <td>f05a93833cfa2542</td>\n",
       "      <td>0f3c399dc9405713</td>\n",
       "      <td>c2f2023d279665b2</td>\n",
       "      <td>...</td>\n",
       "      <td>100</td>\n",
       "      <td>9fefed0a981dcb7a</td>\n",
       "      <td>01092023fb4f373d</td>\n",
       "      <td>99b877d5d88e8478</td>\n",
       "      <td>wte7</td>\n",
       "      <td>105.0</td>\n",
       "      <td>2ecf94369847c748</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2b416f1d7e89ad3b</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     UID  channel  day      time  trans_amt          amt_src1  \\\n",
       "0  19092      102   30  11:48:47       1459  acdbdb842ac20f1e   \n",
       "1  13465      140   23  16:58:03        725  4d7831c6f695ab19   \n",
       "\n",
       "           merchant             code1             code2       trans_type1  \\\n",
       "0  abc6bc660561e0eb  f05a93833cfa2542  0f3c399dc9405713  26bcf43a19df14c8   \n",
       "1  7a87b1aa20972d48  f05a93833cfa2542  0f3c399dc9405713  c2f2023d279665b2   \n",
       "\n",
       "  ...    bal          amt_src2           acc_id2           acc_id3 geo_code  \\\n",
       "0 ...   1007  9fefed0a981dcb7a  01092023fb4f373d  99b877d5d88e8478     wsbq   \n",
       "1 ...    100  9fefed0a981dcb7a  01092023fb4f373d  99b877d5d88e8478     wte7   \n",
       "\n",
       "  trans_type2       market_code market_type           ip1_sub  Tag  \n",
       "0       102.0  2ecf94369847c748         1.0  45f4ca1f4e9b9cb7  1.0  \n",
       "1       105.0  2ecf94369847c748         1.0  2b416f1d7e89ad3b  0.0  \n",
       "\n",
       "[2 rows x 28 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 训练集分析 \n",
    "op_tr = get_operation_train_new()\n",
    "tst_tr = get_transaction_train_new() \n",
    "tst_tr[tag_hd.Tag] = label_train[tag_hd.Tag]\n",
    "op_tr[tag_hd.Tag] = label_train[tag_hd.Tag]\n",
    "op_tr = op_tr.fillna(method=\"ffill\")\n",
    "tst_tr = tst_tr.fillna(method=\"ffill\")\n",
    "# 后向填充，使用下一行的值,不存在的时候就不填充\n",
    "op_tr = op_tr.fillna(method=\"bfill\")\n",
    "tst_tr = tst_tr.fillna(method=\"bfill\")\n",
    "op_tr = fill_mean(op_tr)\n",
    "tst_tr = fill_mean(tst_tr)\n",
    "op_tr.fillna(-1, inplace=True)\n",
    "tst_tr.fillna(-1, inplace=True)\n",
    "# 测试集\n",
    "op_rd1 = get_operation_round1_new()\n",
    "tst_rd1 = get_transaction_round1_new()\n",
    "op_rd1 = op_rd1.fillna(method=\"ffill\")\n",
    "tst_rd1 = tst_rd1.fillna(method=\"ffill\")\n",
    "# 后向填充，使用下一行的值,不存在的时候就不填充\n",
    "op_rd1 = op_rd1.fillna(method=\"bfill\")\n",
    "tst_rd1 = tst_rd1.fillna(method=\"bfill\")\n",
    "op_rd1 = fill_mean(op_rd1)\n",
    "tst_rd1 = fill_mean(tst_rd1)\n",
    "op_rd1.fillna(-1, inplace=True)\n",
    "tst_rd1.fillna(-1, inplace=True)\n",
    "\n",
    "print(op_tr.shape)\n",
    "print(op_tr.shape)\n",
    "tst_tr.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['device2', 'device_code2', 'device_code1', 'day', 'device1', 'time', 'ip1', 'ip1_sub', 'geo_code', 'device_code3', 'mac1']\n",
      "['os', 'ip2_sub', 'mac2', 'success', 'mode', 'ip2', 'version', 'wifi']\n",
      "['trans_type1', 'merchant', 'code1', 'amt_src2', 'acc_id1', 'channel', 'market_type', 'trans_amt', 'acc_id3', 'trans_type2', 'market_code', 'code2', 'acc_id2', 'bal', 'amt_src1']\n"
     ]
    }
   ],
   "source": [
    "op_cols = op_tr.columns.values.tolist()\n",
    "tst_cols = tst_tr.columns.values.tolist()\n",
    "[op_cols.remove(item) for item in tag_header]\n",
    "[tst_cols.remove(item) for item in tag_header]\n",
    "# 交集\n",
    "in_col = list(set(op_cols).intersection(set(tst_cols)))\n",
    "print(in_col)\n",
    "# 差集\n",
    "op_dif = list(set(op_cols).difference(set(in_col)))\n",
    "tst_dif = list(set(tst_cols).difference(set(in_col)))\n",
    "print(op_dif)\n",
    "print(tst_dif)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     UID  op_tst_cnt_rate\n",
      "0  30000         0.090909\n",
      "1  30001         0.333333\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UID</th>\n",
       "      <th>Tag</th>\n",
       "      <th>op_tst_cnt_rate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10000</td>\n",
       "      <td>1</td>\n",
       "      <td>0.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10001</td>\n",
       "      <td>0</td>\n",
       "      <td>0.268657</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     UID  Tag  op_tst_cnt_rate\n",
       "0  10000    1         0.222222\n",
       "1  10001    0         0.268657"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 操作次数与交易次数比值\n",
    "# 对操作表根据用户分组\n",
    "op_tr_uid_gb = op_tr.groupby(tag_hd.UID)\n",
    "op_rd1_uid_gb = op_rd1.groupby(tag_hd.UID)\n",
    "# 对 交易表 根据用户分组\n",
    "tst_tr_uid_gb = tst_tr.groupby(tag_hd.UID)\n",
    "tst_rd1_uid_gb = tst_rd1.groupby(tag_hd.UID)\n",
    "#\n",
    "op_tr_cnt = op_tr_uid_gb['day'].count().reset_index()\n",
    "tst_tr_cnt = tst_tr_uid_gb['day'].count().reset_index()\n",
    "op_rd1_cnt = op_rd1_uid_gb['day'].count().reset_index()\n",
    "tst_rd1_cnt = tst_rd1_uid_gb['day'].count().reset_index()\n",
    "label_train['op_tst_cnt_rate']  = tst_tr_cnt['day']/op_tr_cnt['day']\n",
    "label_test['op_tst_cnt_rate']  = tst_rd1_cnt['day']/op_rd1_cnt['day']\n",
    "print(label_test.head(2))\n",
    "label_train.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['UID', 'sum', 'mean', 'amax', 'amin', 'std', 'var']\n",
      "['UID', 'op_tst_sum', 'op_tst_mean', 'op_tst_amax', 'op_tst_amin', 'op_tst_std', 'op_tst_var']\n",
      "123\n"
     ]
    }
   ],
   "source": [
    "op_tr_ftr = op_tr_uid_gb['day'].agg([np.sum, np.mean, np.max, np.min, np.std, np.var]).reset_index()\n",
    "cols =  list(op_tr_ftr.columns.values)\n",
    "print(cols)\n",
    "cols.remove('UID')\n",
    "cols = ['op_tst_'+item for item in cols]\n",
    "cols02 = ['UID']\n",
    "cols02.extend(cols)\n",
    "print(cols02)\n",
    "op_tr_ftr.columns = cols02 \n",
    "tst_tr_ftr = tst_tr_uid_gb['day'].agg([np.sum, np.mean, np.max, np.min, np.std, np.var]).reset_index()\n",
    "tst_tr_ftr.columns = cols02\n",
    "print(123)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(30542, 7)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>op_tst_sum</th>\n",
       "      <th>op_tst_mean</th>\n",
       "      <th>op_tst_amax</th>\n",
       "      <th>op_tst_amin</th>\n",
       "      <th>op_tst_std</th>\n",
       "      <th>op_tst_var</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>182</td>\n",
       "      <td>20.222222</td>\n",
       "      <td>26</td>\n",
       "      <td>13</td>\n",
       "      <td>6.851602</td>\n",
       "      <td>46.944444</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   op_tst_sum  op_tst_mean  op_tst_amax  op_tst_amin  op_tst_std  op_tst_var\n",
       "0         182    20.222222           26           13    6.851602   46.944444"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(tst_tr_ftr.shape)\n",
    "op_tr_ftr[cols].head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>op_tst_sum</th>\n",
       "      <th>op_tst_mean</th>\n",
       "      <th>op_tst_amax</th>\n",
       "      <th>op_tst_amin</th>\n",
       "      <th>op_tst_std</th>\n",
       "      <th>op_tst_var</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>52</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   op_tst_sum  op_tst_mean  op_tst_amax  op_tst_amin  op_tst_std  op_tst_var\n",
       "0          52         26.0           26           26         0.0         0.0"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tst_tr_ftr[cols].head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>op_tst_sum</th>\n",
       "      <th>op_tst_mean</th>\n",
       "      <th>op_tst_amax</th>\n",
       "      <th>op_tst_amin</th>\n",
       "      <th>op_tst_std</th>\n",
       "      <th>op_tst_var</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.285714</td>\n",
       "      <td>1.285714</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.491991</td>\n",
       "      <td>1.831299</td>\n",
       "      <td>2.307692</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.212393</td>\n",
       "      <td>4.894681</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.272727</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.266667</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.325581</td>\n",
       "      <td>1.581395</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>1.172262</td>\n",
       "      <td>1.374198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.320755</td>\n",
       "      <td>2.245283</td>\n",
       "      <td>2.125000</td>\n",
       "      <td>2.428571</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.265517</td>\n",
       "      <td>0.493103</td>\n",
       "      <td>0.846154</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>1.645701</td>\n",
       "      <td>2.708333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.125000</td>\n",
       "      <td>0.937500</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1.954023</td>\n",
       "      <td>1.116585</td>\n",
       "      <td>1.111111</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>1.068770</td>\n",
       "      <td>1.142270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1.341667</td>\n",
       "      <td>1.533333</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.432432</td>\n",
       "      <td>0.864865</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.714286</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.024390</td>\n",
       "      <td>0.780488</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>1.200000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.576705</td>\n",
       "      <td>1.922348</td>\n",
       "      <td>1.034483</td>\n",
       "      <td>3.750000</td>\n",
       "      <td>0.709392</td>\n",
       "      <td>0.503236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.235294</td>\n",
       "      <td>3.176471</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>22.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.304469</td>\n",
       "      <td>0.989525</td>\n",
       "      <td>0.966667</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.758258</td>\n",
       "      <td>0.574956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.046368</td>\n",
       "      <td>0.533230</td>\n",
       "      <td>0.517241</td>\n",
       "      <td>0.652174</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0.677215</td>\n",
       "      <td>0.451477</td>\n",
       "      <td>0.733333</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.521853</td>\n",
       "      <td>0.272331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0.897163</td>\n",
       "      <td>1.009309</td>\n",
       "      <td>1.034483</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>1.310881</td>\n",
       "      <td>1.718408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0.010698</td>\n",
       "      <td>1.021618</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0.013263</td>\n",
       "      <td>0.053050</td>\n",
       "      <td>0.045455</td>\n",
       "      <td>0.066667</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1.293651</td>\n",
       "      <td>0.754630</td>\n",
       "      <td>1.611111</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>12.278912</td>\n",
       "      <td>1.130952</td>\n",
       "      <td>1.428571</td>\n",
       "      <td>0.095238</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0.146141</td>\n",
       "      <td>0.890133</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.749861</td>\n",
       "      <td>0.562291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0.076923</td>\n",
       "      <td>1.230769</td>\n",
       "      <td>0.782609</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1.276596</td>\n",
       "      <td>5.319149</td>\n",
       "      <td>2.222222</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>3.709402</td>\n",
       "      <td>0.608099</td>\n",
       "      <td>1.034483</td>\n",
       "      <td>0.045455</td>\n",
       "      <td>2.865875</td>\n",
       "      <td>8.213240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0.459596</td>\n",
       "      <td>0.722222</td>\n",
       "      <td>1.277778</td>\n",
       "      <td>0.111111</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0.400000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0.366906</td>\n",
       "      <td>0.917266</td>\n",
       "      <td>0.689655</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.839132</td>\n",
       "      <td>0.704143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0.245902</td>\n",
       "      <td>0.737705</td>\n",
       "      <td>0.814815</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.413844</td>\n",
       "      <td>1.998954</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30512</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30513</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30514</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30515</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30516</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30517</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30518</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30519</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30520</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30521</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30522</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30523</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30524</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30525</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30526</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30527</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30528</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30529</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30530</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30531</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30532</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30533</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30534</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30535</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30536</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30537</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30538</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30539</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30540</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30541</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>30542 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       op_tst_sum  op_tst_mean  op_tst_amax  op_tst_amin  op_tst_std  \\\n",
       "0        0.285714     1.285714     1.000000     2.000000    0.000000   \n",
       "1        0.491991     1.831299     2.307692     1.000000    2.212393   \n",
       "2        0.272727     1.000000     1.000000     1.000000         NaN   \n",
       "3        0.266667     1.000000     1.000000     1.000000         NaN   \n",
       "4        0.325581     1.581395     1.000000     8.000000    1.172262   \n",
       "5        0.320755     2.245283     2.125000     2.428571         NaN   \n",
       "6        0.265517     0.493103     0.846154     0.055556    1.645701   \n",
       "7        0.125000     0.937500     0.600000     6.000000    0.000000   \n",
       "8        1.954023     1.116585     1.111111     0.333333    1.068770   \n",
       "9        1.341667     1.533333     2.000000     0.400000         inf   \n",
       "10       0.432432     0.864865     0.666667     1.714286    0.000000   \n",
       "11       0.024390     0.780488     0.600000     1.200000    0.000000   \n",
       "12       0.576705     1.922348     1.034483     3.750000    0.709392   \n",
       "13       0.235294     3.176471     1.000000    22.000000    0.000000   \n",
       "14       0.304469     0.989525     0.966667     2.000000    0.758258   \n",
       "15       0.046368     0.533230     0.517241     0.652174    0.000000   \n",
       "16       0.677215     0.451477     0.733333     1.000000    0.521853   \n",
       "17       0.897163     1.009309     1.034483     0.250000    1.310881   \n",
       "18       0.010698     1.021618     0.800000    12.000000    0.000000   \n",
       "19       0.013263     0.053050     0.045455     0.066667    0.000000   \n",
       "20       1.293651     0.754630     1.611111     0.055556         inf   \n",
       "21      12.278912     1.130952     1.428571     0.095238         inf   \n",
       "22       0.146141     0.890133     0.800000     2.000000    0.749861   \n",
       "23       0.076923     1.230769     0.782609     9.000000         NaN   \n",
       "24       1.276596     5.319149     2.222222    10.000000    0.000000   \n",
       "25       3.709402     0.608099     1.034483     0.045455    2.865875   \n",
       "26       0.459596     0.722222     1.277778     0.111111         inf   \n",
       "27       0.400000     1.000000     1.000000     1.000000         NaN   \n",
       "28       0.366906     0.917266     0.689655     1.000000    0.839132   \n",
       "29       0.245902     0.737705     0.814815     0.666667    1.413844   \n",
       "...           ...          ...          ...          ...         ...   \n",
       "30512         NaN          NaN          NaN          NaN         NaN   \n",
       "30513         NaN          NaN          NaN          NaN         NaN   \n",
       "30514         NaN          NaN          NaN          NaN         NaN   \n",
       "30515         NaN          NaN          NaN          NaN         NaN   \n",
       "30516         NaN          NaN          NaN          NaN         NaN   \n",
       "30517         NaN          NaN          NaN          NaN         NaN   \n",
       "30518         NaN          NaN          NaN          NaN         NaN   \n",
       "30519         NaN          NaN          NaN          NaN         NaN   \n",
       "30520         NaN          NaN          NaN          NaN         NaN   \n",
       "30521         NaN          NaN          NaN          NaN         NaN   \n",
       "30522         NaN          NaN          NaN          NaN         NaN   \n",
       "30523         NaN          NaN          NaN          NaN         NaN   \n",
       "30524         NaN          NaN          NaN          NaN         NaN   \n",
       "30525         NaN          NaN          NaN          NaN         NaN   \n",
       "30526         NaN          NaN          NaN          NaN         NaN   \n",
       "30527         NaN          NaN          NaN          NaN         NaN   \n",
       "30528         NaN          NaN          NaN          NaN         NaN   \n",
       "30529         NaN          NaN          NaN          NaN         NaN   \n",
       "30530         NaN          NaN          NaN          NaN         NaN   \n",
       "30531         NaN          NaN          NaN          NaN         NaN   \n",
       "30532         NaN          NaN          NaN          NaN         NaN   \n",
       "30533         NaN          NaN          NaN          NaN         NaN   \n",
       "30534         NaN          NaN          NaN          NaN         NaN   \n",
       "30535         NaN          NaN          NaN          NaN         NaN   \n",
       "30536         NaN          NaN          NaN          NaN         NaN   \n",
       "30537         NaN          NaN          NaN          NaN         NaN   \n",
       "30538         NaN          NaN          NaN          NaN         NaN   \n",
       "30539         NaN          NaN          NaN          NaN         NaN   \n",
       "30540         NaN          NaN          NaN          NaN         NaN   \n",
       "30541         NaN          NaN          NaN          NaN         NaN   \n",
       "\n",
       "       op_tst_var  \n",
       "0        0.000000  \n",
       "1        4.894681  \n",
       "2             NaN  \n",
       "3             NaN  \n",
       "4        1.374198  \n",
       "5             NaN  \n",
       "6        2.708333  \n",
       "7        0.000000  \n",
       "8        1.142270  \n",
       "9             inf  \n",
       "10       0.000000  \n",
       "11       0.000000  \n",
       "12       0.503236  \n",
       "13       0.000000  \n",
       "14       0.574956  \n",
       "15       0.000000  \n",
       "16       0.272331  \n",
       "17       1.718408  \n",
       "18       0.000000  \n",
       "19       0.000000  \n",
       "20            inf  \n",
       "21            inf  \n",
       "22       0.562291  \n",
       "23            NaN  \n",
       "24       0.000000  \n",
       "25       8.213240  \n",
       "26            inf  \n",
       "27            NaN  \n",
       "28       0.704143  \n",
       "29       1.998954  \n",
       "...           ...  \n",
       "30512         NaN  \n",
       "30513         NaN  \n",
       "30514         NaN  \n",
       "30515         NaN  \n",
       "30516         NaN  \n",
       "30517         NaN  \n",
       "30518         NaN  \n",
       "30519         NaN  \n",
       "30520         NaN  \n",
       "30521         NaN  \n",
       "30522         NaN  \n",
       "30523         NaN  \n",
       "30524         NaN  \n",
       "30525         NaN  \n",
       "30526         NaN  \n",
       "30527         NaN  \n",
       "30528         NaN  \n",
       "30529         NaN  \n",
       "30530         NaN  \n",
       "30531         NaN  \n",
       "30532         NaN  \n",
       "30533         NaN  \n",
       "30534         NaN  \n",
       "30535         NaN  \n",
       "30536         NaN  \n",
       "30537         NaN  \n",
       "30538         NaN  \n",
       "30539         NaN  \n",
       "30540         NaN  \n",
       "30541         NaN  \n",
       "\n",
       "[30542 rows x 6 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "op_tst_rate = tst_tr_ftr[cols]/op_tr_ftr[cols]\n",
    "op_tst_rate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>op_tst_sum</th>\n",
       "      <th>op_tst_mean</th>\n",
       "      <th>op_tst_amax</th>\n",
       "      <th>op_tst_amin</th>\n",
       "      <th>op_tst_std</th>\n",
       "      <th>op_tst_var</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>130.0</td>\n",
       "      <td>-5.777778</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-13.0</td>\n",
       "      <td>6.851602</td>\n",
       "      <td>46.944444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>222.0</td>\n",
       "      <td>-5.422056</td>\n",
       "      <td>-17.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-4.995962</td>\n",
       "      <td>-66.133827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>232.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>187.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>290.0</td>\n",
       "      <td>-7.352941</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-7.0</td>\n",
       "      <td>-1.649491</td>\n",
       "      <td>-34.310160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>36.0</td>\n",
       "      <td>-9.428571</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>-10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>213.0</td>\n",
       "      <td>11.307692</td>\n",
       "      <td>4.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>-2.680304</td>\n",
       "      <td>-29.435897</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>504.0</td>\n",
       "      <td>1.200000</td>\n",
       "      <td>12.0</td>\n",
       "      <td>-15.0</td>\n",
       "      <td>13.453368</td>\n",
       "      <td>180.993103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>-166.0</td>\n",
       "      <td>-1.690476</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-0.657335</td>\n",
       "      <td>-12.998268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>-41.0</td>\n",
       "      <td>-8.000000</td>\n",
       "      <td>-15.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>-8.306624</td>\n",
       "      <td>-69.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>63.0</td>\n",
       "      <td>1.875000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>5.693041</td>\n",
       "      <td>32.410714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1440.0</td>\n",
       "      <td>5.062500</td>\n",
       "      <td>12.0</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>6.519507</td>\n",
       "      <td>42.503968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>149.0</td>\n",
       "      <td>-10.822222</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-11.0</td>\n",
       "      <td>2.575570</td>\n",
       "      <td>39.019349</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>143.0</td>\n",
       "      <td>-15.074074</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-21.0</td>\n",
       "      <td>7.342845</td>\n",
       "      <td>53.917379</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>498.0</td>\n",
       "      <td>0.192308</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>2.775453</td>\n",
       "      <td>56.027236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>617.0</td>\n",
       "      <td>13.130435</td>\n",
       "      <td>14.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.455533</td>\n",
       "      <td>2.118577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>51.0</td>\n",
       "      <td>8.666667</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.993959</td>\n",
       "      <td>155.688889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>29.0</td>\n",
       "      <td>-0.145833</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-2.398610</td>\n",
       "      <td>-42.766422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4439.0</td>\n",
       "      <td>-0.507853</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-22.0</td>\n",
       "      <td>7.287963</td>\n",
       "      <td>53.114412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>372.0</td>\n",
       "      <td>17.850000</td>\n",
       "      <td>21.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>3.572924</td>\n",
       "      <td>12.765789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>-37.0</td>\n",
       "      <td>4.416667</td>\n",
       "      <td>-11.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>-10.273163</td>\n",
       "      <td>-105.537879</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>-1658.0</td>\n",
       "      <td>-2.750000</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>-7.642207</td>\n",
       "      <td>-58.403333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1040.0</td>\n",
       "      <td>1.997286</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>2.667887</td>\n",
       "      <td>49.791678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>216.0</td>\n",
       "      <td>-3.375000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-16.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>-26.0</td>\n",
       "      <td>-16.240000</td>\n",
       "      <td>-11.0</td>\n",
       "      <td>-18.0</td>\n",
       "      <td>2.758019</td>\n",
       "      <td>7.606667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>-634.0</td>\n",
       "      <td>9.170492</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>-5.507054</td>\n",
       "      <td>-62.835337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>107.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>-9.780934</td>\n",
       "      <td>-95.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>48.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>176.0</td>\n",
       "      <td>1.150000</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.570031</td>\n",
       "      <td>28.181203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>414.0</td>\n",
       "      <td>5.333333</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-1.774449</td>\n",
       "      <td>-18.365385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30512</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30513</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30514</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30515</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30516</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30517</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30518</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30519</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30520</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30521</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30522</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30523</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30524</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30525</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30526</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30527</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30528</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30529</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30530</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30531</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30532</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30533</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30534</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30535</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30536</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30537</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30538</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30539</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30540</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30541</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>30542 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       op_tst_sum  op_tst_mean  op_tst_amax  op_tst_amin  op_tst_std  \\\n",
       "0           130.0    -5.777778          0.0        -13.0    6.851602   \n",
       "1           222.0    -5.422056        -17.0          0.0   -4.995962   \n",
       "2           232.0     0.000000          0.0          0.0    0.000000   \n",
       "3           187.0     0.000000          0.0          0.0    0.000000   \n",
       "4           290.0    -7.352941          0.0         -7.0   -1.649491   \n",
       "5            36.0    -9.428571         -9.0        -10.0         NaN   \n",
       "6           213.0    11.307692          4.0         17.0   -2.680304   \n",
       "7           504.0     1.200000         12.0        -15.0   13.453368   \n",
       "8          -166.0    -1.690476         -3.0          4.0   -0.657335   \n",
       "9           -41.0    -8.000000        -15.0          9.0   -8.306624   \n",
       "10           63.0     1.875000          6.0         -5.0    5.693041   \n",
       "11         1440.0     5.062500         12.0         -3.0    6.519507   \n",
       "12          149.0   -10.822222         -1.0        -11.0    2.575570   \n",
       "13          143.0   -15.074074          0.0        -21.0    7.342845   \n",
       "14          498.0     0.192308          1.0         -2.0    2.775453   \n",
       "15          617.0    13.130435         14.0          8.0    1.455533   \n",
       "16           51.0     8.666667          8.0          0.0    6.993959   \n",
       "17           29.0    -0.145833         -1.0          6.0   -2.398610   \n",
       "18         4439.0    -0.507853          6.0        -22.0    7.287963   \n",
       "19          372.0    17.850000         21.0         14.0    3.572924   \n",
       "20          -37.0     4.416667        -11.0         17.0  -10.273163   \n",
       "21        -1658.0    -2.750000         -9.0         19.0   -7.642207   \n",
       "22         1040.0     1.997286          6.0         -2.0    2.667887   \n",
       "23          216.0    -3.375000          5.0        -16.0         NaN   \n",
       "24          -26.0   -16.240000        -11.0        -18.0    2.758019   \n",
       "25         -634.0     9.170492         -1.0         21.0   -5.507054   \n",
       "26          107.0     5.000000         -5.0         16.0   -9.780934   \n",
       "27           48.0     0.000000          0.0          0.0    0.000000   \n",
       "28          176.0     1.150000          9.0          0.0    1.570031   \n",
       "29          414.0     5.333333          5.0          4.0   -1.774449   \n",
       "...           ...          ...          ...          ...         ...   \n",
       "30512         NaN          NaN          NaN          NaN         NaN   \n",
       "30513         NaN          NaN          NaN          NaN         NaN   \n",
       "30514         NaN          NaN          NaN          NaN         NaN   \n",
       "30515         NaN          NaN          NaN          NaN         NaN   \n",
       "30516         NaN          NaN          NaN          NaN         NaN   \n",
       "30517         NaN          NaN          NaN          NaN         NaN   \n",
       "30518         NaN          NaN          NaN          NaN         NaN   \n",
       "30519         NaN          NaN          NaN          NaN         NaN   \n",
       "30520         NaN          NaN          NaN          NaN         NaN   \n",
       "30521         NaN          NaN          NaN          NaN         NaN   \n",
       "30522         NaN          NaN          NaN          NaN         NaN   \n",
       "30523         NaN          NaN          NaN          NaN         NaN   \n",
       "30524         NaN          NaN          NaN          NaN         NaN   \n",
       "30525         NaN          NaN          NaN          NaN         NaN   \n",
       "30526         NaN          NaN          NaN          NaN         NaN   \n",
       "30527         NaN          NaN          NaN          NaN         NaN   \n",
       "30528         NaN          NaN          NaN          NaN         NaN   \n",
       "30529         NaN          NaN          NaN          NaN         NaN   \n",
       "30530         NaN          NaN          NaN          NaN         NaN   \n",
       "30531         NaN          NaN          NaN          NaN         NaN   \n",
       "30532         NaN          NaN          NaN          NaN         NaN   \n",
       "30533         NaN          NaN          NaN          NaN         NaN   \n",
       "30534         NaN          NaN          NaN          NaN         NaN   \n",
       "30535         NaN          NaN          NaN          NaN         NaN   \n",
       "30536         NaN          NaN          NaN          NaN         NaN   \n",
       "30537         NaN          NaN          NaN          NaN         NaN   \n",
       "30538         NaN          NaN          NaN          NaN         NaN   \n",
       "30539         NaN          NaN          NaN          NaN         NaN   \n",
       "30540         NaN          NaN          NaN          NaN         NaN   \n",
       "30541         NaN          NaN          NaN          NaN         NaN   \n",
       "\n",
       "       op_tst_var  \n",
       "0       46.944444  \n",
       "1      -66.133827  \n",
       "2        0.000000  \n",
       "3        0.000000  \n",
       "4      -34.310160  \n",
       "5             NaN  \n",
       "6      -29.435897  \n",
       "7      180.993103  \n",
       "8      -12.998268  \n",
       "9      -69.000000  \n",
       "10      32.410714  \n",
       "11      42.503968  \n",
       "12      39.019349  \n",
       "13      53.917379  \n",
       "14      56.027236  \n",
       "15       2.118577  \n",
       "16     155.688889  \n",
       "17     -42.766422  \n",
       "18      53.114412  \n",
       "19      12.765789  \n",
       "20    -105.537879  \n",
       "21     -58.403333  \n",
       "22      49.791678  \n",
       "23            NaN  \n",
       "24       7.606667  \n",
       "25     -62.835337  \n",
       "26     -95.666667  \n",
       "27       0.000000  \n",
       "28      28.181203  \n",
       "29     -18.365385  \n",
       "...           ...  \n",
       "30512         NaN  \n",
       "30513         NaN  \n",
       "30514         NaN  \n",
       "30515         NaN  \n",
       "30516         NaN  \n",
       "30517         NaN  \n",
       "30518         NaN  \n",
       "30519         NaN  \n",
       "30520         NaN  \n",
       "30521         NaN  \n",
       "30522         NaN  \n",
       "30523         NaN  \n",
       "30524         NaN  \n",
       "30525         NaN  \n",
       "30526         NaN  \n",
       "30527         NaN  \n",
       "30528         NaN  \n",
       "30529         NaN  \n",
       "30530         NaN  \n",
       "30531         NaN  \n",
       "30532         NaN  \n",
       "30533         NaN  \n",
       "30534         NaN  \n",
       "30535         NaN  \n",
       "30536         NaN  \n",
       "30537         NaN  \n",
       "30538         NaN  \n",
       "30539         NaN  \n",
       "30540         NaN  \n",
       "30541         NaN  \n",
       "\n",
       "[30542 rows x 6 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda root]",
   "language": "python",
   "name": "conda-root-py"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}
